USE [DSRSystem]
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Access to Health Care focuses on the management of access to medicine and/or the access to health care equipment and services to disadvantaged communities and groups. This ESG issue is mainly of relevance for companies in the health care industry as well as for research-driven companies in the pharmaceutical and biotechnology industry. In addition, it applies to selected companies in the industrial conglomerates and traders & distributors industry that have significant pharmaceutical or health care business units.'
 WHERE [ExternalId] = 21 -- Access To Health Care
GO
UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Bribery and corruption focuses on the management of risks related to the potential illegal payments, such as kickbacks, bribes and facilitation payments to government officers, as well as the receipt of those payments from suppliers or business partners. In the extractive industry, the issue also covers adoption of relevant transparency standards with regards to payments to host governments in the form of taxes and royalties.'
 WHERE [ExternalId] = 8 -- Bribery and Corruption
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Business Ethics focuses on how companies manage issues related to business ethics including topics such as anti-competitive practices, accounting practices, management of intellectual property rights. Depending on the industry, it can also cover money laundering, clinical trials, animal testing, genetic engineering, responsible gaming and the use of controversial technologies such as stem cell research and nanotechnology.'
 WHERE [ExternalId] = 20 -- Business Ethics
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Community Relations focuses on how companies manage relations with local communities (including indigenous communities). Local communities typically comprise communities in the vicinity of a company''s operating sites or communities directly impacted by these. Depending on the industry, the emphasis is put on community involvement, community development and/or measures to reduce negative impacts on local communities.'
 WHERE [ExternalId] = 14 -- Community Relations
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Data Privacy and Security focuses on how companies collect, use, manage, and protect personal information and metadata collected from data subjects. Emphasis is put on measures taken to ensure safe and secure use and/or secure maintenance of personal data including, but not limited to, those required to comply with relevant legislation. In some sectors, this includes managing the risks associated with government data requests that may result in persecution and violations of civil and political rights.'
 WHERE [ExternalId] = 10 -- Data Privacy and Security
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Emissions Effluents and Waste focuses on the management of emissions and releases from operations to air, water and land excluding GHG emissions. Depending on the industry, the emphasis is put on one or several of these three ''waste streams''. Management of shipwrecking is also covered under this ESG issue as well as nuclear waste.'
 WHERE [ExternalId] = 5 -- Emissions, Effluents and Waste
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Energy Use and GHG Emissions focuses on the management of energy use and GHG emissions from operations including transportation and logistics, as well as the regulatory and market risks of climate change regulations. Depending on the industry, the emphasis is put on topics such as energy consumption, energy efficiency and/or energy mix as well as regulatory risks related to climate change.'
 WHERE [ExternalId] = 2 -- Energy Use and GHG Emissions
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Health and Safety focuses on the management of health and safety amongst employees and contractors. Depending on the industry and where relevant, topics also include HIV/Aids programmes.'
 WHERE [ExternalId] = 6 -- Health and Safety
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Human Capital focuses on the management of labour relations and/or the management of business risks as a result of demographic changes notably skills shortages. Depending on the industry, the emphasis can be more on the former (e.g. retailing) or the latter (e.g. machinery) or both. It also includes the management of core labour rights such as freedom of association and non-discrimination.'
 WHERE [ExternalId] = 1 -- Human Capital
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Human Rights focuses on how companies manage the respect human rights within their sphere of influence. Particular focus is put on measures taken to protect civil and political rights as well economic, social and cultural rights as enshrined in the UN Universal Declaration of Human Rights including its covenants.  Labour rights and civil rights and political rights related to the use of private data are covered under different ESG issues.'
 WHERE [ExternalId] = 31 -- Human Rights
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Media Ethics focuses on how companies manage ethical standards and integrity in the media including news journalism. The emphasis is on editorial standards, advertising ethics and management of conflicts of interests.'
 WHERE [ExternalId] = 22 -- Media Ethics
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Biodiversity focuses on how companies manage biodiversity, including land use and the impact of the company''s operations on ecosystems and wildlife. Topics covered include land conversion, forest management as well as protection of biodiversity and ecosystems. Depending on the industry, the focus can be on land use, biodiversity or both.'
 WHERE [ExternalId] = 13 -- Land Use and Biodiversity
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Physical Climate Change Risks focuses on how companies manage physical risks posed by climate change, i.e.  higher frequencies of extreme weather events including draughts, flooding, storms, heat waves etc. The emphasis is put on companies'' approach to risk assessment and risk management to protect corporate assets from such risks.'
 WHERE [ExternalId] = 9 -- Physical Impacts of Climate Change
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Product/Service Quality and Safety focuses on how companies manage the quality and/or safety of their products and ultimately client relations. Emphasis is put on quality management systems as well as companies management of sales and marketing activities. Specific topics may also include after sales service, management of products recalls and fair billing.'
 WHERE [ExternalId] = 11 -- Product Quality and Safety
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Resilience focuses on the financial stability and the management of related risks in the financial services industry. This ESG issue is limited to those financial institutions that pose systemic risks and therefore potential external costs to society in case of bail outs by taxpayers. Topics include capital adequacy, focus on real economy, sources of financing and proximity to clients.'
 WHERE [ExternalId] = 19 -- Resilience
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Responsible Finance focuses on how companies in the financial sector manage their product and service offering to reduce or minimise the direct or indirect negative impacts from their investment, lending or insurance activities. Topics include responsible investment, responsible lending, access to finance, etc.'
 WHERE [ExternalId] = 18 -- Responsible Finance
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Supply Chain focuses on how companies manage social and/or environmental impacts in their supply chain. Social topics include labour rights and working conditions (including child and forced labour), as well as conflict minerals. Environmental topics include energy efficiency, eco-efficiency and sustainable sourcing.'
 WHERE [ExternalId] = 4 -- Supply Chain
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Products Sustainability focuses on the management of social, health or environmental impacts of products or services that are inherent to the product or service (i.e. not related to quality problems and/or the way they are marketed). Depending on the industry, topics may include recycling, reuse, eco-design, the health impact of fast food or tobacco, environmental or social performance metrics of products, social exclusion, etc.'
 WHERE [ExternalId] = 3 -- Product Sustainability
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Water Use focuses on the management of water use and reporting of risks related to water scarcity through the company''s operations or its supply chain. Depending on the industry, the emphasis is put on the former, the latter or both dimensions. The issue focuses on the use of water as a raw material, not on the treatment and management of process water, which is covered under Emissions, Releases and Waste.'
 WHERE [ExternalId] = 7 -- Water Use
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Financial Product Governance focuses on how companies in the financial services industry manage responsibilities towards clients covering all areas of product development and governance, from identifying targets for the products, through sales and marketing practices, to post-sales responsibility. It cover topics such as predatory lending and customer relations.'
 WHERE [ExternalId] = 17 -- Financial Product Governance
GO

UPDATE [dbo].[KeyESGIssues]
   SET [Description] = 'Animal Welfare focuses on the management of housing, feeding, healthcare, transportation and slaughtering activities to ensure the wellbeing of animals raised for human consumption, mainly livestock and poultry, throughout the company''s own operations or its supply chain. It covers issues such as freedom from hunger, thirst, discomfort, stress and pain, as well as the animals'' freedom to express normal behaviour.'
 WHERE [ExternalId] = 32 -- Animal Welfare
GO
